﻿using System;

namespace edowork.com.Model
{
    #region billsInfo

    [Serializable]
    public class billsInfo
    {
        #region Private fields

        protected string _billsno = String.Empty;
        protected string _aPPID = String.Empty;
        protected string _billdate = String.Empty;
        protected string _billtype = String.Empty;
        protected string _remark = String.Empty;
        protected string _userid = String.Empty;
        protected string _sysdate = String.Empty;
        protected string _billto = String.Empty;
        protected string _shipto = String.Empty;
        protected string _transportid = String.Empty;
        protected string _logisticsid = String.Empty;
        protected string _expressno = String.Empty;
        protected string _load_no = String.Empty;
        protected string _reserve_no = String.Empty;
        protected string _caseqty = String.Empty;
        protected decimal _freight;
        protected string _checkuserid = String.Empty;
        protected string _checkstu = String.Empty;
        protected string _checkdate = String.Empty;
        protected string _checkremark = String.Empty;
        protected string _m_stu = String.Empty;
        protected string _m_date = String.Empty;
        protected string _m_ID = String.Empty;

        #endregion

        public billsInfo() { }

        #region Public Properties

        public string Billsno
        {
            get { return _billsno; }
            set { _billsno = value; }
        }

        public string APPID
        {
            get { return _aPPID; }
            set { _aPPID = value; }
        }

        public string Billdate
        {
            get { return _billdate; }
            set { _billdate = value; }
        }

        public string Billtype
        {
            get { return _billtype; }
            set { _billtype = value; }
        }

        public string Remark
        {
            get { return _remark; }
            set { _remark = value; }
        }

        public string Userid
        {
            get { return _userid; }
            set { _userid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        public string Billto
        {
            get { return _billto; }
            set { _billto = value; }
        }

        public string Shipto
        {
            get { return _shipto; }
            set { _shipto = value; }
        }

        public string Transportid
        {
            get { return _transportid; }
            set { _transportid = value; }
        }

        public string Logisticsid
        {
            get { return _logisticsid; }
            set { _logisticsid = value; }
        }

        public string Expressno
        {
            get { return _expressno; }
            set { _expressno = value; }
        }

        public string Load_no
        {
            get { return _load_no; }
            set { _load_no = value; }
        }

        public string Reserve_no
        {
            get { return _reserve_no; }
            set { _reserve_no = value; }
        }

        public string Caseqty
        {
            get { return _caseqty; }
            set { _caseqty = value; }
        }

        public decimal Freight
        {
            get { return _freight; }
            set { _freight = value; }
        }

        public string Checkuserid
        {
            get { return _checkuserid; }
            set { _checkuserid = value; }
        }

        public string Checkstu
        {
            get { return _checkstu; }
            set { _checkstu = value; }
        }

        public string Checkdate
        {
            get { return _checkdate; }
            set { _checkdate = value; }
        }

        public string Checkremark
        {
            get { return _checkremark; }
            set { _checkremark = value; }
        }

        public string M_stu
        {
            get { return _m_stu; }
            set { _m_stu = value; }
        }

        public string M_date
        {
            get { return _m_date; }
            set { _m_date = value; }
        }

        public string M_ID
        {
            get { return _m_ID; }
            set { _m_ID = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into bills(Billsno,APPID,Billdate,Billtype,Remark,Userid,Sysdate,Billto,Shipto,Transportid,Logisticsid,Expressno,Load_no,Reserve_no,Caseqty,Freight,Checkuserid,Checkstu,Checkdate,Checkremark,M_stu,M_date,M_ID) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}',{15},'{16}','{17}','{18}','{19}','{20}','{21}','{22}')";
        }

        #endregion

    }

    #endregion
}

